7.16 实例5 将数据透视表拆分为工作簿
import pandas as pd
df=pd.read_excel(r "D:\Pyobject2023\object\测试\素材\1.7.14 实例3 提取各分组下唯一值.xlsx" )
print (df)
total_df=df.pivot_table(
columns =df.财务日期.dt.strftime( "%Y%m月" ), #对年月进行整理
index =[ "细分市场","产品名称" ],
aggfunc={ "收入":"sum" }
)
for t ,d in total_df.groupby( "细分市场" ): #对total_df里面的细分市场进行分工作簿
d.droplevel(level=0).to_excel( "测试文件1\\"+ t + ".xlsx" )